Tabela OncologyBasic

Definicja tabeli OncologyBasic

Name

OncologyBasic

Code

OncologyBasic

Comment

Tabela przechowujaca dane dotyczace diagnostyki podstawowej


Lista kolumn tabeli OncologyBasic

Name

Code

OncologyBasicID

OncologyBasicID

OncologicCardID

OncologicCardID

OtherSymptomDescrID

OtherSymptomDescrID

OtherPerfTestDescrID

OtherPerfTestDescrID

TumourICDID

TumourICDID

OtherInformationDescrID

OtherInformationDescrID

ConsultationDoctorTypeID

ConsultationDoctorTypeID

ConsultationDoctorOther

ConsultationDoctorOther

DiagnosisDoctorID

DiagnosisDoctorID

IssuingOrgUnitID

IssuingOrgUnitID

FurtherProceedingSpecialityID

FurtherProceedingSpecialityID


Kolumna OncologyBasicID tabeli OncologyBasic

Definicja kolumny OncologyBasicID tabeli OncologyBasic

Name

OncologyBasicID

Code

OncologyBasicID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Klucz glówny


Kolumna OncologicCardID tabeli OncologyBasic

Definicja kolumny OncologicCardID tabeli OncologyBasic

Name

OncologicCardID

Code

OncologicCardID

Data Type

NUMBER(10)

Mandatory

No

Comment

Id karty


Kolumna OtherSymptomDescrID tabeli OncologyBasic

Definicja kolumny OtherSymptomDescrID tabeli OncologyBasic

Name

OtherSymptomDescrID

Code

OtherSymptomDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

Opis innych objawów


Kolumna OtherPerfTestDescrID tabeli OncologyBasic

Definicja kolumny OtherPerfTestDescrID tabeli OncologyBasic

Name

OtherPerfTestDescrID

Code

OtherPerfTestDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

Opis innych wykonanych badan


Kolumna TumourICDID tabeli OncologyBasic

Definicja kolumny TumourICDID tabeli OncologyBasic

Name

TumourICDID

Code

TumourICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

ICDID nowotworu


Kolumna OtherInformationDescrID tabeli OncologyBasic

Definicja kolumny OtherInformationDescrID tabeli OncologyBasic

Name

OtherInformationDescrID

Code

OtherInformationDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

Inne informacje


Kolumna ConsultationDoctorTypeID tabeli OncologyBasic

Definicja kolumny ConsultationDoctorTypeID tabeli OncologyBasic

Name

ConsultationDoctorTypeID

Code

ConsultationDoctorTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Typ lekarza do konsultacji


Kolumna ConsultationDoctorOther tabeli OncologyBasic

Definicja kolumny ConsultationDoctorOther tabeli OncologyBasic

Name

ConsultationDoctorOther

Code

ConsultationDoctorOther

Data Type

VARCHAR2(200)

Mandatory

No

Comment

Lekarz do konsultacji – inny


Kolumna DiagnosisDoctorID tabeli OncologyBasic

Definicja kolumny DiagnosisDoctorID tabeli OncologyBasic

Name

DiagnosisDoctorID

Code

DiagnosisDoctorID

Data Type

NUMBER(10)

Mandatory

No

Comment

Diagnostyka podstawowa - lekarz wydajacy


Kolumna IssuingOrgUnitID tabeli OncologyBasic

Definicja kolumny IssuingOrgUnitID tabeli OncologyBasic

Name

IssuingOrgUnitID

Code

IssuingOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

Diagnostyka podstawowa - swiadczeniodawca wydajacy


Kolumna FurtherProceedingSpecialityID tabeli OncologyBasic

Definicja kolumny FurtherProceedingSpecialityID tabeli OncologyBasic

Name

FurtherProceedingSpecialityID

Code

FurtherProceedingSpecialityID

Data Type

NUMBER(10)

Mandatory

No

Comment

Kolumna odpowiada za specjalizacje 'orgUnita' nastepnego etapu realizowanego w ramach karty onkologicznej


Lista kluczy tabeli OncologyBasic

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli OncologyBasic

Definicja klucza Identifier_1 tabeli OncologyBasic

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment